Database for storing electrical power signatures of household devices

This paper describes the storage of electrical signals from a software framework that provides an automated diagnosis of household devices, based on power signature analysis. Storing power signatures of household devices into a database helps us in two ways: it meets the criteria for operation of the automatic diagnosis algorithm and ensures the possibility of performing future benchmarks tests to establish the performance of the algorithm. The initial electrical signal is stored into the database both in normal and in normalized format (according to amplitude). The results for each stage of signal processing and signal analysis are stored in different tables, together with the best results obtained and the methods that led to them. The article describes the creation and maintenance of this database and details the methods of data accessing. A series of stored procedures allows the user quick access to desired data whether he wants to access the full signal or only a part of it.